</a>
The Global Ice Cream Market is growing at a CAGR of 4.9% during the forecast period (2020-2025) [1].
Three key emerging trends that will affect change across the industry [2]:
According to ice cream market insights is still possible to be a new player into a saturated environment, only under specific conditions, so target will be to produce organic handcrafted ice cream with signature flavors - Niche product + Health concern + Favor Trends - in US (largest Market for Ice Cream).
The focus of this analysis will be to obtain the best locations for a production center. It is not the intention to offer specific coordinates, just to point towards an initial area to help decision-making for niche ice cream manofacturers.
Consequently, the location of the production centers must meet the achievement of the following premises:
Logistics department of a Handcrafted Organic ice cream manufacturer.
Report will highlight the location of areas suitable to minimize global costs in Supply + Physical Distribution to position production center.
Data 1 :
This dataset exists for free on the web. Link to the dataset is : https://organic.ams.usda.gov/integrity/. Once populated certified products filter with required supplies and country (United States os America) DDBB can be exported to Excel.
Data 2 :
https://en.wikipedia.org/wiki/List_of_United_States_cities_by_population
Data 3 :
United States Census Bureau - Median Household Income by State: 2019. Source: 2014-2018 American Community Survey 5-Year Estimates
Link directs to a table that can be downloaded in csv format - Median Household Income by State.csv
Data 4 :
United States Census Bureau - Individuals Below Poverty Level by State : 2019.Source: 2020 Current Population Survey Annual Social and Economic Supplement (CPS ASEC).
https://www.census.gov/search-results.html?searchType=web&cssp=SERP&q=poverty
Link directs to a table that can be downloaded in csv format- Individuals Below Poverty Level by State.csv
Data 5 :
The resulting searches are limited to 50 responses and the maximum radius of search is 100,000 meters. Foursquare API has advantages to tabulate all the venues near a particular position, but is cumbersome for acquiring clean data such as all super markets of one city. To overcome limitations we will use neighborhoods structure as an area slicer, also we will limit search results bu ussing categoryid of Supermarket(52f2ab2ebcbc57f1066b8b46) and Gourmet Shop (4bf58dd8d48988d1f5941735).
Neighborhoods datasets:
New York City dataset - https://cocl.us/new_york_dataset
Chicago data origin - https://en.wikipedia.org/wiki/List_of_neighborhoods_in_Chicago - Chicago Neighborhoods.csv
Philadelphia data origin - https://www.visitphilly.com/areas/philadelphia-neighborhoods/ - Philadelphia Neighborhoods.csv
LA data origin - https://enacademic.com/dic.nsf/enwiki/800534 - LA Neighborhoods.csv
San Diego data origin - https://en.wikipedia.org/wiki/List_of_communities_and_neighborhoods_of_San_Diego - San Diego Neighborhoods.csv
San Jose data origin - https://en.wikipedia.org/wiki/Category:Neighborhoods_in_San_Jose,_California - San Jose Neighborhoods.csv
Houston - https://en.wikipedia.org/wiki/List_of_Houston_neighborhoods
Even getting a filtered dataset from United States Department of Agriculture (USDA) - Organic integrity Database, the products we are looking for are diseminated in different cattegories: CROPS, HANDLING and LIVESTOCK certified colums.
First step is restructure data to clasify organic productions units according to whether or not they have the required products.
Reduce dataset cols to the ones needed for the analysis.
Group certified product into a single col to make analysis easier and rename cols.
For this analysis we will keep only Organic Operations that can provide the suppy needed - Milk, Fruit, Soy or Tapioca.
Number of Organic Operations in scope
Second step is to group Organic Operations by State
Count operations per State
Count operation by category and State
Once data set is ready we will include geographic coordinates(latitude and longitude) to prepare some visualizations
Geolocating process is not able to locate 1318 organic operations
Next dataset shows top 5 afected States by null geolocation -
Caveat - It has not been able to geolocate 1318 operations (9232 Total). Most impacted state for graphs is Wisconsin loosing more than 30% of their Organic industry --> 843 - 384. Not so much impact for California, New york and Pennsylvania.